package com.xhh.nphm.system.mapper;

import com.xhh.nphm.system.domain.TmSensitiveAddress;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Administrator
* @description 针对表【tm_sensitive_address】的数据库操作Mapper
* @createDate 2022-06-13 17:17:03
* @Entity com.xhh.nphm.system.domain.TmSensitiveAddress
*/
@Mapper
public interface TmSensitiveAddressDao extends BaseMapper<TmSensitiveAddress> {
    /**
     * 查询特殊地点列表数据
     *
     * @param sensitiveAddress 封装特殊地点查询条件
     * @return 列表数据
     */
    @Select("SELECT pkId,sensitiveAddress FROM tm_sensitive_address WHERE isDel = 0 " +
            "[[AND sensitiveAddress =#{sensitiveAddress}]]")
    List<TmSensitiveAddress> listJson(TmSensitiveAddress sensitiveAddress);
}




